package com.catalina.service;

import java.io.IOException;
import java.util.List;

import org.apache.poi.ss.usermodel.Workbook;

import com.catalina.entity.User;

public interface UserService {

	public User select(String name, String password);

	public void insert(User user);

	public void update(User user);

	public void delete(int id);

	public List<User> selectList(String sort, String order);//得到全部数据

	public Integer getTotal(String name);//得到总数

	public List<User> selectList(Integer page, Integer rows, String name, String sort, String order);//得到datagrid数据

	public Integer deleteList(String str);

	public Workbook exportToExcel(String[] title, String fileName, List<User> userList) throws IOException;

}
